Re: MySQL Queries (OT?)

by Nathan <natelyle(at)chartermi.net>

Date:	Thu, 24 Jan 2002 21:48:39 -0500
To:	Frank Boumphrey <bckman(at)ix.netcom.com>
Cc:	HWG Techniques Email List <hwg-techniques(at)hwg.org>
References:
	todo: View Thread, Original

>If you are using joins for three tables then it will be slow!
>If you have 1000 records in each table, you are essentially looking at
>1000^3 , or one billion operations for your search!

This is what I was just realizing yesterday as I looked at what I was
doing. I'm going to try to work out a way to do this without as many joins.

~ Nathan Lyle

Email: natelyle(at)chartermi.net
Phone: (906)485-4806
http://www.nathanlyle.com

"Those that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." - Ben Franklin

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA